Analysis of COVID-19 Cases in UK (England)ΒΆ
IntroductionΒΆ
This report analyzes COVID-19 case data in England to identify patterns over time.
We use the UKHSA dataset, in this analysis, we will be focusing on the date and metric_value columns. The metric value is the rate of cases per 100,000 (7-day rolling average).
Data DescriptionΒΆ
The dataset includes the following columns:
- date β the date of test specimen collection
- geography β reporting region (England)
- metric_value β Case rates by specimen date (7-day rolling average)
We'll focus on date and metric_value to create a time-series chart.
| theme | sub_theme | topic | geography_type | geography | metric | sex | age | stratum | year | date | metric_value | in_reporting_delay_period | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-10 | 2.23 | False |
| 1 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-09 | 2.59 | False |
| 2 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-08 | 2.80 | False |
| 3 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-07 | 2.82 | False |
| 4 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-06 | 2.78 | False |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 370 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-05 | 2.99 | False |
| 371 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-04 | 2.97 | False |
| 372 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-03 | 3.03 | False |
| 373 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-02 | 2.99 | False |
| 374 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-01 | 2.91 | False |
375 rows Γ 13 columns
Data CleaningΒΆ
The data has been sorted to ensure correct chronological order. In order to plot an interactive graph, the data was sorted in way that we have a x,y plot.
X values are the Dates while the Y values are the Case Rate
| theme | sub_theme | topic | geography_type | geography | metric | sex | age | stratum | year | date | metric_value | in_reporting_delay_period | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 374 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-01 | 2.91 | False |
| 373 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-02 | 2.99 | False |
| 372 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-03 | 3.03 | False |
| 371 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-04 | 2.97 | False |
| 370 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2024 | 2024-09-05 | 2.99 | False |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 4 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-06 | 2.78 | False |
| 3 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-07 | 2.82 | False |
| 2 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-08 | 2.80 | False |
| 1 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-09 | 2.59 | False |
| 0 | infectious_disease | respiratory | COVID-19 | Nation | England | COVID-19_cases_rateRollingMean | all | all | default | 2025 | 2025-09-10 | 2.23 | False |
375 rows Γ 13 columns
374 2024-09-01
373 2024-09-02
372 2024-09-03
371 2024-09-04
370 2024-09-05
...
4 2025-09-06
3 2025-09-07
2 2025-09-08
1 2025-09-09
0 2025-09-10
Name: date, Length: 375, dtype: object
374 2.91
373 2.99
372 3.03
371 2.97
370 2.99
...
4 2.78
3 2.82
2 2.80
1 2.59
0 2.23
Name: metric_value, Length: 375, dtype: float64
VisualizationΒΆ
The chart shows the overall trend of COVID-19 case rates over time. Hover over the chart to see exact values for any date.
Findings & InsightsΒΆ
From the chart, we can see that:
- The highest number of cases occurred in October 2024.
- There was a sharp decline after this peak.
- Case rates have been relatively stable since 2025.
This suggests that interventions such as vaccines may have contributed to a lower case rate over time.